package com.czc.cca.ddl;

import org.zoomdev.zoom.dao.ddl.SqlType;
import org.zoomdev.zoom.dao.ddl._DDL_Column;
import org.zoomdev.zoom.dao.ddl._DDL_Primary;
import org.zoomdev.zoom.dao.ddl._DDL_Table;
import org.zoomdev.zoom.dao.driver.mysql.MysqlDriver;

@_DDL_Table(name = "user_update_bank_card", simpleName = "", engine = MysqlDriver.InnoDB, comment = "用户更新银行卡")
public class _DDL_UserUpdateBankCard {

    @_DDL_Primary()
    @_DDL_Column(name = "UPDATE_ID", type = SqlType.INT, nullable = false, autoIncrement = true, comment = "更新ID")
    private Integer id;

    @_DDL_Column(name = "UPDATE_TYPE", type = SqlType.INT, nullable = false, comment = "更新类型，-1：解绑、0：默认卡、1：绑定")
    private Integer type;

    @_DDL_Column(name = "USER_ID", type = SqlType.INT, nullable = false, comment = "用户ID")
    private Integer userId;

    @_DDL_Column(name = "MOBILE_NO", type = SqlType.VARCHAR, size = 20, comment = "手机号")
    private String mobileNo;

    @_DDL_Column(name = "BANK_NAME", type = SqlType.VARCHAR, size = 50, comment = "银行名称")
    private String bankName;

    @_DDL_Column(name = "BIND_CARD_NO", type = SqlType.VARCHAR, size = 20, nullable = false, comment = "绑定的银行卡号")
    private String bindCardNo;

    @_DDL_Column(name = "BUSINESS_NO", type = SqlType.VARCHAR, size = 35, comment = "业务流水号")
    private String businessNo;

    @_DDL_Column(name = "UPDATE_STATUS", type = SqlType.VARCHAR, size = 2, comment = "更新状态，-1：异常、0：失败、1：成功")
    private String status;

    @_DDL_Column(name = "ERROR_CODE", type = SqlType.VARCHAR, size = 1000, comment = "错误码")
    private String errorCode;

    @_DDL_Column(name = "ERROR_MSG", type = SqlType.VARCHAR, size = 500, comment = "错误内容")
    private String errorMsg;

    @_DDL_Column(name = "CREATE_TIME", type = SqlType.VARCHAR, size = 19, nullable = false, comment = "创建时间")
    private String createTime;

    @_DDL_Column(name = "UPDATE_TIME", type = SqlType.VARCHAR, size = 19, comment = "更新时间")
    private String time;

    @_DDL_Column(name = "MOBILE_NO_CIPHERTEXT", type = SqlType.VARCHAR, size = 100, comment = "手机号密文")
    private String mobileNoCiphertext;

    @_DDL_Column(name = "BIND_CARD_NO_CIPHERTEXT", type = SqlType.VARCHAR, size = 100, comment = "绑定的银行卡号密文")
    private String bindCardNoCiphertext;

}
